Overview
Briefly describe the contents of the report and its purpose.
Custom terminology allows you to define the retail terminology used within your business. Once defined, terminology automatically appears on criteria forms and reports. For more information on defining custom terminology refer to the article Custom Terminology.
Criteria Form
Refer to the article Report Criteria Form Standard Field Operation for help with the standard criteria form fields.
The following table describes the operation of non-standard fields where appropriate.
| Field | Description |
|---|---|
| Report Date | This date field indicates date for the report to be generated. |
| Number of Weeks | This numeric entry field indicates number of previous weeks to be included in the report generated to Report Date entered. |
| Sort By | This drop-down field allows the user to view the report by a variety of sorting options. |
| Asc/Desc | This drop-down field defines if the rows will increase or decrease in the sort order. Asc stands for Ascending, while Desc stands for Descending. |
Reports
Refer to the section Understanding the Intelligence Store Data for help with the standard values included in Retail Arena reporting.
The following table describes non-standard columns where appropriate.
| Column | Description |
|---|---|
| Avg Item | This column shows the sales dollar value divided by the units for the given week. This figure gives the user the average sale price per item. |
| Productivity | This column shows the Sales Dollar value divided by hours. This gives the retailer an idea of the employee sales level. For example if Employee A had a productivity level of $239. That would tell the user that Employee A makes on average $239 per hour. |
| ATV | This column show the average transaction value. |
| UPT | This column shows the units per transaction. |
Remarks
Level 1 Report - Showing the current Period and Previous Weeks
Level 2 Report - Showing the Number of Previous Weeks to Report Date
Level 3 Report - Employee Productivity Report
Level 4 Report - Total {Showing Every Transaction from the Number of Weeks to Report Date}
Technical Reference
This section contains technical information about the various source objects for this report and parameters and customization that affect the reports operation. Refer to the article Form Customization and Parameters to understand how parameters, form customization, and security settings affect report and report criteria form operations.
| Property | Value |
| Form Name | Arena_ATVUPTReport |
| Form Customization JScript File Name | Arena_ATVUPTReport.js |
| Report Definition Name | Arena_ATVUPTReport |
| Permission Name | Arena_ATVUPTReport |
| Property | Value |
| RDL Name | Arena_ATVUPTReport.rdl |
| Stored Procedure Name |
Arena_EmployeeProductivityAudit_V3 |
| Supports Enhanced Store Security (See System::StoreEnhancedSecurityEnabled paramter). | No |
| Supports Enhanced Product Security (See System::ProductEnhancedSecurityEnabled paramter) | No |
| Supports Currency Conversion | Yes |
| Honours the System::AggregateSalesIncludeNonInventory parameter. | No |
| Honours the System::SalesAndTargetsIncludeTax parameter. | No |
| Honours the System::UseConcessionStoreSales parameter. | No |
| Honours the System::ReleaseQuantityCalculationMethod parameter. | No |
|
Uses the LiveDataViews::Store_Employee_Day_Values parameter. |
No |
|
Uses the LiveDataViews::Current_Stock parameter. |
No |
| Property | Value |
| RDL Name | Arena_ATVUPTReport2.rdl |
| Stored Procedure Name |
Arena_EmployeeProductivityAudit_V3 |
| Supports Enhanced Store Security (See System::StoreEnhancedSecurityEnabled paramter). | No |
| Supports Enhanced Product Security (See System::ProductEnhancedSecurityEnabled paramter) | No |
| Supports Currency Conversion | Yes |
| Honours the System::AggregateSalesIncludeNonInventory parameter. | No |
| Honours the System::SalesAndTargetsIncludeTax parameter. | No |
| Honours the System::UseConcessionStoreSales parameter. | No |
| Honours the System::ReleaseQuantityCalculationMethod parameter. | No |
|
Uses the LiveDataViews::Store_Employee_Day_Values parameter. |
No |
|
Uses the LiveDataViews::Current_Stock parameter. |
No |
| Property | Value |
| RDL Name | Arena_ATVUPTReport_Total.rdl |
| Stored Procedure Name |
Arena_EmployeeProductivityAudit_V3 |
| Supports Enhanced Store Security (See System::StoreEnhancedSecurityEnabled paramter). | No |
| Supports Enhanced Product Security (See System::ProductEnhancedSecurityEnabled paramter) | No |
| Supports Currency Conversion | Yes |
| Honours the System::AggregateSalesIncludeNonInventory parameter. | No |
| Honours the System::SalesAndTargetsIncludeTax parameter. | No |
| Honours the System::UseConcessionStoreSales parameter. | No |
| Honours the System::ReleaseQuantityCalculationMethod parameter. | No |
|
Uses the LiveDataViews::Store_Employee_Day_Values parameter. |
No |
|
Uses the LiveDataViews::Current_Stock parameter. |
No |
| Property | Value |
| RDL Name | Arena_ATVUPTReport3.rdl |
| Stored Procedure Name |
Arena_EmployeeProductivityAuditByWeek_V2 |
| Supports Enhanced Store Security (See System::StoreEnhancedSecurityEnabled paramter). | No |
| Supports Enhanced Product Security (See System::ProductEnhancedSecurityEnabled paramter) | No |
| Supports Currency Conversion | Yes |
| Honours the System::AggregateSalesIncludeNonInventory parameter. | No |
| Honours the System::SalesAndTargetsIncludeTax parameter. | No |
| Honours the System::UseConcessionStoreSales parameter. | No |
| Honours the System::ReleaseQuantityCalculationMethod parameter. | No |
|
Uses the LiveDataViews::Store_Employee_Day_Values parameter. |
No |
|
Uses the LiveDataViews::Current_Stock parameter. |
No |